
load data
INTO TABLE Expected_ALLstockInfo
APPEND
FIELDS TERMINATED BY ',' 
TRAILING NULLCOLS 
(StockCode ,
StockDate date 'yyyy/mm/dd' ,	 
open   ,
high   ,
low   ,
close   ,
volume  ,
MA5     ,
MA10   ,
MA20   ,
MA30    ,
MA60   ,
VOL_VOLUME   ,
VOL_MA5    ,
VOL_MA10   ,
CCI   ,
MACD_DIF   ,
MACD_DEA   ,
MACD_MACD   ,
KDJ_K   ,
KDJ_D   ,
KDJ_J,
MyKDJK,
MYKDJD,
MYKDJJ)
